CREATE EXTERNAL TABLE IF NOT EXISTS jms_ods.lq_self_pickup_task(
id                                                 bigint                         COMMENT '',
version                                            bigint                         COMMENT '',
createTime                                         String                         COMMENT '',
lastUpdateTime                                     String                         COMMENT '',
serviceSiteCode                                    String                         COMMENT '服务点编码',
orderId                                            bigint                         COMMENT '订单ID',
instorageTime                                      String                         COMMENT '入库时间',
taskTime                                           bigint                         COMMENT '任务时间',
receiverPhone                                      String                         COMMENT '收件人手机号',
phoneLastFour                                      String                         COMMENT '手机号后4位',
shelfName                                          String                         COMMENT '货架名',
shelfNumber                                        String                         COMMENT '货架号',
goodsNumber                                        String                         COMMENT '货号（取件码）',
queueNumber                                        bigint                         COMMENT '排队号',
wxUserId                                           String                         COMMENT '微信用户ID',
status                                             smallint                       COMMENT '状态',
headImg                                            String                         COMMENT '头像',
nickname                                           String                         COMMENT '昵称',
userPhone                                          String                         COMMENT '绑定手机号',
substitutePhone                                    String                         COMMENT '代取手机号'
)
COMMENT ''
PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS PARQUET
LOCATION '/dw/hive/jms_ods.db/external/lq_self_pickup_task'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
);